SQL For Beginners: A Step-by-Step Guide to Learn SQL (Structured Query Language) from Installation to Database Management and Database Administration. by McKinnon Julian James

Author:McKinnon, Julian James [McKinnon, Julian James]
Language: eng
Format: epub
Published: 2020-02-07T16:00:00+00:00

Chapter 7: Using VIEWS in SQL

VIEWS are virtual tables or stored SQL queries in the databases that have predefined queries and unique names.

They are actually the resulting tables from your SQL queries.

As a beginner, you may want to learn about how you can use VIEWS.

Among their numerous uses is their flexibility can combine rows and columns from VIEWS.

Here are important pointers and advantages in using VIEWS:

You can summarize data from different tables or a subset of columns from various tables.

You can control what users of your databases can see, and restrict what you don’t want them to view.

You can organize your database for your users’ easy manipulation, while simultaneously protecting your non-public files.

You can modify, or edit, or UPDATE your data. Sometimes there are limitations, though, such as being able to access only one column when using VIEW.

You can create columns from various tables for your reports.

You can increase the security of your databases because VIEWS can display only the information that you want to be displayed.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.